You are here: Configuration > Allocations > Allocation Database Tables

Allocation Database Tables

When a user assigns allocations in OIPA, the AsAllocations table stores the fund allocation data attached to a policy, a plan or an activity.

Configuration can be tested by creating a policy and attaching allocations. Verify the correct records were written to the database. Allocations are linked to a policy via the AsAllocations table, using the RELATEDGUID and the POLICYGUID from the AsPolicy table. The GROUPGUID is used to combine allocations that were made at the same time, where each allocation has its own ALLOCATIONGUID.